Thread: Hidden sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Heera[_2_] Heera[_2_] is offline
external usenet poster
 
Posts: 26
Default Hidden sheets

Hi,

I want a macro which should run a procedure if a sheet is hidden(not
visiable).
(My workbook is password protected)

I want a code which will identify the sheet is hidden or not. Here is my
code but is is not working.

If Sheets("Letter Audit Sheet").Hidden = True Then
Activecell.value=1520
Exit Sub
End if

Please help