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: 83
Default Global Sheet Protection and a Button

Hello,
I am currently running Excel 2003.
My problem is this.
I have a w/sheet that allows users to enter data into selected cells. In
other cells there are various LOOKUPS base on their input. I have created a
Button from the Forms toolbar and attached a macro to it that allows the user
to clear down the w/sheet each time prior to using the w/sheet,whilst
protecting the LOOKUP cells. In protecting the worksheet the button also
appears to be protected and not accessible to the user.
Can anyone suggest an answer to my problem
Thank you
 
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
Range name: Change from sheet specific to global CinqueTerra Excel Discussion (Misc queries) 2 July 12th 06 11:51 PM
Sheet Protection wally Excel Worksheet Functions 8 May 21st 06 09:28 PM
Command Button protection problems???? Chris Watson Excel Worksheet Functions 3 February 25th 06 03:24 PM
Sheet Protection seezzell Excel Worksheet Functions 2 October 15th 05 12:57 AM
How do I create a command button to jump from sheet to sheet in a. Darlenew Excel Worksheet Functions 3 March 22nd 05 10:36 PM


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