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: 8
Default Bug when Sheet Protection Activated

I have command buttons on every sheet relating to every sheet
When I activate protection on my sheet called "Totals" and when I click on
the "Totals" from any of the other sheets i receive a debug message.

When protection is off, the command buttons function normally
The code reads
Private Sub CommandButton16_Click()
'
Application.Goto Reference:="Totals"
End Sub

I would be very grateful for any ideas
 
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
Macro to run when sheet activated Gary Keramidas Excel Programming 0 December 13th 06 09:27 PM
Macro to run when sheet activated Dave Miller Excel Programming 1 December 13th 06 09:26 PM
userform open when sheet activated ADK Excel Programming 11 September 7th 06 06:36 PM
Load VBA on Activated Sheet RigasMinho Excel Programming 2 July 25th 06 04:20 PM
Error sheet when macro's are not activated jgmiddel Excel Programming 0 March 22nd 06 09:28 PM


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