Way to by pass PW to hide sheet

  • Thread starter Thread starter Cam Hua
  • Start date Start date
C

Cam Hua

Hello,

I have a sheet in my workbook that need to be protected, then hidden. I
need to write a macro to perform these task.
I ran into the problem with the macro because the sheet can not be
protected in order to be protected. It gave me an error.

Is there a way in the macro to protected the sheet then hide the sheet
by ignoring the protection? Thanks

Cameron
 
Try some code like the following:

Dim WS As Worksheet
Set WS = Worksheets("Sheet1")
WS.Visible = xlSheetHidden
WS.Protect Password:="ThePassword"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

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

Novice - using macro to protect with password 10
Copy data using macro (with worksheet protect) 5
preventing referencing hidden cell 3
"How do I un/protect sheet by macro program with password 5
password protect individual sheets 1
Protect workbook question 5
Hide a sheet based on a cell condition 7
Running Macros in a Shared File 2

Back
Top