LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default Macros and protect sheet

I need to do different things at once in my worksheet.

1. I need a macro to select a value from an autofilter (that part is done)
2. I need to protect the sheet (exept a few inputcells), the sheet
containing various formulas (this is also done)
3. I need both at the same time....

The macro stops when it should select a spesific value in the autofilter. I
have formatted the cells in the filter (and the inputcells) to be hidden, not
locked, and the sheet is protected - and the user can choose unlocked cells
and use the autofilter.

Do I need to install some function into vb? I needed this when I wanted
another macro to make pivottables, but I cannot remember why.

I hope someone can help me with this, I have a really short deadline. Thanks!

traima
 
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
run macros on protected sheet widman Excel Discussion (Misc queries) 4 December 10th 06 10:09 AM
Password protect a sheet without Macros Cappa Excel Discussion (Misc queries) 3 May 27th 06 01:49 AM
protecting macros for a protected sheet Jon Excel Discussion (Misc queries) 3 March 29th 06 03:32 PM
Protect macros? JulieD Excel Discussion (Misc queries) 6 August 25th 05 08:38 PM
help with protect sheet WYN Excel Discussion (Misc queries) 14 February 18th 05 10:26 PM


All times are GMT +1. The time now is 10:08 PM.

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"