Hidden sheets

H

Heera

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
 
M

Mike H

Hi,

Try this

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy text and logo from protected, hidden sheet 1
prompt password for a worksheet 5
Problem with UserForm1.Show 4
how to make macro work even a sheet is hidden. 3
Hidden sheet tabs (to store data)??? 2
How to hide password? 1
Compare 2 sheets 1
HIDE / UNHIDE sheets based on user answers 5

Top