LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 98
Default Proteting against a button press

Hi:

I have a spreadsheet containing buttons which activate macros. I want to protect one
sheet in the workbook so that no one can write on it, and no one can activate the buttons
without a password. When I protect sheet, I find that while the cells are protected the
button can be activated.

Can someone tell me how to set the BUTTONS so that they cant be pressed and activate the
macros.

Thanks a lot

JOhn Baker
 
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
find&press button Alex New Users to Excel 1 February 18th 10 03:39 PM
urgent help!find&press,please Alex Excel Discussion (Misc queries) 0 February 18th 10 11:37 AM
Is It Possible To Have... After A Button Press A Message Pops Up ? Chris Excel Worksheet Functions 2 May 30th 08 04:03 PM
When I Press the Enter Key Nothing happens. bigev Excel Discussion (Misc queries) 1 March 1st 06 03:05 PM
test for key press Robert Chapman Excel Programming 6 October 6th 03 05:31 PM


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