Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 195
Default button in a protected sheet

try this

put this at the start of you macro
Worksheets(1).UnProtect ("Pwd")

put this at the end of you macro
Worksheets(1).Protect ("Pwd")

PS you need to change these to use your password and refer to the
correct sheet


Frigster wrote:
Hi,

I have a button in a sheet.
When i protect the sheet the button doesn't work anymore. It could be
pressed but the code doesn't make anything.
In the properties of button I tried to select and deselect the option
"blocked" but... no way.

Where am I going wrong?

Thanks a lot.
Paolo.


Reply
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
Allow custom update button to work while sheet is protected mhng Excel Discussion (Misc queries) 0 July 14th 06 12:39 AM
use macro button to run macro in protected sheet earl Excel Discussion (Misc queries) 3 February 26th 06 10:21 PM
radio button on protected worksheet Rog[_4_] Excel Programming 3 December 29th 04 08:07 PM
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet arunjoshi[_5_] Excel Programming 1 May 2nd 04 03:50 PM
Command Button not working once sheet is protected Janice[_3_] Excel Programming 5 November 17th 03 10:22 PM


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