Works well. Thank you, Carim.
Posts by wildkid
-
-
Can you help me write VBA code that activate the cell that is at the top of the column of the ActiveCell?
-
Like this right?
Thank you for your help.[SIZE=13px]
Code[/SIZE][/FONT][/COLOR][/align][align=left][COLOR=#252C2F][FONT=Courier][SIZE=12px]Sub Hiddenwindows()[/SIZE][/FONT][/COLOR][/align]Dim Cnt as IntegerDim Win as windowCnt=0For each Win in WindowsIf Not Win.Visible then Cnt = Cnt +1Next WinMsgbox Cnt & " hidden windows"[align=left][COLOR=#252C2F][FONT=Courier][SIZE=12px]End Sub[/SIZE][/FONT][/COLOR][/align][align=left][COLOR=#252C2F][FONT=Helvetica][SIZE=13px]
[/SIZE][/FONT][/COLOR]
[/align]
-
[SIZE=13px]I suddenly realize I hid worksheets not WINDOWS. That's it always gives me 0 hidden windows. duh..[/SIZE]
-
I need to count the number of windows that are hidden and display a pop-up window. My code keep giving me "0 hidden windows" no matter how many windows I've hidden, please help.