LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Protect menu options dimmed

I have a spreadsheet that was given to me. It opens with no problems;
I am not asked for a password. Every cell is protected, even the ones
I need to add data to or change.

Tools, Protection, Unprotect Sheet and Unprotect Workbook are both
dimmed out. On the File menu, Properties is also dimmed.

When I go into the VBA editor and click on the one project listed, I
get a dialog box titled Project Locked and a message "Project is
unviewable."

First, I would like to know how to do this to some of my spreadsheets.
Second, is there a way I can unprotect the worksheets?

Thank you,
Deborah

 
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
Drop-down menu options conksu Excel Discussion (Misc queries) 3 April 27th 06 06:50 PM
Tools/Options/Charts-Active cells is dimmed. Want to select leave teds Charts and Charting in Excel 9 April 13th 06 04:02 PM
Cannot get into the 'options' menu, any suggestions? Iceman Excel Discussion (Misc queries) 2 March 10th 06 01:26 AM
Options Menu abarger123 Excel Discussion (Misc queries) 5 August 17th 05 04:38 PM
in Execl is it possible to lock/protect the options Mark Excel Discussion (Misc queries) 2 March 3rd 05 01:53 AM


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

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

About Us

"It's about Microsoft Excel"