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: 8
Default Protecting sheets with drop down boxes

I have an excel spreadsheet that has drop down boxes and formulas. I want to
be able to protect this spreadsheet so that other user will not delete my
formulas. I password protected the spreadsheet, however, when this sheet is
protected i am not able to select from the drop down list. Is there a macro
that I can incorporate into my worksheet that would help me with this
problem. If so, can you please give me the codes needed?

Thanks.
 
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
Protecting sheets with drop down boxes Dolores Gomez[_2_] Excel Worksheet Functions 0 April 9th 10 04:13 PM
Drop down boxes/tick boxes Jane Excel Worksheet Functions 2 October 28th 08 04:02 PM
combo boxes & protecting worksheets Renee Excel Worksheet Functions 9 March 25th 08 02:49 PM
Protecting Check Boxes to prevent editing Lindey Excel Discussion (Misc queries) 1 January 31st 08 10:17 PM
Protecting Sheets Joyce Excel Worksheet Functions 3 March 20th 06 08:18 PM


All times are GMT +1. The time now is 04:10 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"