Thread: Hidden sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Hidden sheets

Hi,

Try this

If Sheets("Letter Audit Sheet").Visible = True Then
ActiveCell.Value = 1520
Exit Sub
End If

Mike

"Heera" wrote:

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