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: 80
Default One button, one macro, several sheets

I have a workbook with a lot of simular sheets. On each sheet I want to have
the same button that directs the user to a central sheet (where, of course,
is a button which redirects the user to where he/she came from).

To create one button is not the problem. To copy the button to all the other
sheets, whithout having to rename the "Commandbutton1" and to copy the VBA
code to all the other sheets is the problem.

So, I am looking for a central place for the macro (This Worksheet??) and a
way to in the first place and a way to "tell" my commandbutton where to look
for that macro.

Thanks for your help in advance,

Henk

 
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
"Form / Button" Macro for Unhiding Sheets Melissa Excel Discussion (Misc queries) 0 September 5th 08 06:07 PM
Macro button to print sheets populated from drop-down list AB3 Excel Discussion (Misc queries) 7 July 11th 08 01:03 AM
Trying to set Option button values in macro on protected sheets Damon Excel Programming 4 July 9th 05 10:37 PM
Pause macro, add form button to sheet, continue macro when button clicked! Flystar[_15_] Excel Programming 1 May 26th 04 09:45 AM
Creating an "update" button and using a macro to copy data from multiple sheets SPIRITTTJ Excel Programming 1 January 8th 04 05:50 PM


All times are GMT +1. The time now is 08:52 AM.

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"