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 Unable to assign macros to a new button in the current worksheet

How can I get the vba macros I've written to show up in the "Assign Macro"
windows when I open it to assign a maro to a button on the worksheet I am
building?

This never used to be a problem. It is probably related to all the security
crap one has to deal with now. Macro "Security" in OFFICE has been set to
Low.

The steps are this:
1. I have about 7 macros in "Sheet 1" of the spreadsheet I currently have
open in Excel 2003. I can see all 15 macros in the "VBA Project" window of
the VBA Editor, including one new one I have just written. I can also see 6
other macros I've previously written in VBA code and which work fine.

2. Sometime ago, I created six buttons on the spreadsheet and attached
these macros to them. These six buttons work fine (the macros do what they
are supposed to do).

3. Now I wnat to add one more macro. It is a carbon copy of the others
except I want to attach it to a new button, so new code needs to be written
for this button. I simply copied the code for one of the existing buttons
(e.g., HideF1_Click) within the code window and renamed it (e.g. to
HideBY_Click).

4. Then, I created a new button on the spreadsheet using the Forms Toolbar.
I clicked on the "button" image on the Toolbar and then moved the cursor to
where I wanted the button and drew it.

5. Fine, the button was created and the Assign Macro window opened but NO
MACROS show up in it.

6. Why not?

7. "Sheet1" in the VBA Project window where all the macros are (including
the new one) is seelected. I can see all seven macros in the VBA Project
window but none show up in the "Assign Macro" window.

So the problem is that the code is written and available in "Sheet1" of the
current workbook and the button where the code should be assigned is there,
but the code is not connected to the button.

John
 
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
Assign different macros for True/False button Ken G. Excel Discussion (Misc queries) 2 April 3rd 09 04:50 AM
Place a button on a worksheet and assign a macro to it? PFB New Users to Excel 7 December 18th 08 03:28 PM
Protecting a worksheet which has button controlled macros Clinton Walker Excel Programming 0 September 21st 06 04:48 AM
Protecting a worksheet which has button controlled macros Clinton Walker Excel Discussion (Misc queries) 0 September 8th 06 03:21 AM
Unable to Assign Value To Cell Aanika Excel Programming 1 January 12th 04 03:18 PM


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