Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
AnisaF
 
Posts: n/a
Default Unlock formulas and unhide sheets

Can and body help me to unlock formulas and unhide sheets that are password
protected?

Thanks in advance.
--
Anisa
  #2   Report Post  
JMB
 
Posts: n/a
Default Unlock formulas and unhide sheets

To make all sheets visible try this macro

Sub test2()
For Each x In Sheets
x.Visible = True
Next x
End Sub


To undo worksheet protection, try this link:

http://j-walk.com/ss/excel/faqs/pw.txt

"AnisaF" wrote:

Can and body help me to unlock formulas and unhide sheets that are password
protected?

Thanks in advance.
--
Anisa

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turning off auto unhide when calculating formulas Pedro Jimenez Excel Worksheet Functions 11 December 14th 04 11:41 AM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"