My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Help
|
|
 Dec 19 2003, 10:04 AM
Post
#1
|
|
|
UtterAccess Addict Posts: 122 From: Houston, TX  |
I am running into a problem. When I go to edit the Macros for my spread-sheet, I can select the macro to edit from my list Tools->Macros->Macros. But if I select any of the macros for the workbook I am using the "Edit" button is grayed out and I cannot access the macro code. If I go to run the macro from my button in the workbook, I get the message: The macro "MyWorkbook.xls'!MyMacro' cannot be found.
Is there any way to force Excel to let me into the code? I think I can fix this If I can just edit the macro but Excel won't let me look at it. |
 |
 
|
|
Dec 19 2003, 10:12 AM
Post
#2
|
|
|
UtterAccess Member Posts: 21 From: New Milford, CT |
Hit Alt+F11 to go into the VBA
|
|
|
|
|
Dec 19 2003, 10:17 AM
Post
#3
|
|
|
UtterAccess Addict Posts: 122 From: Houston, TX |
Don't work. Any other ideas?
|
|
|
|
|
Dec 19 2003, 11:40 AM
Post
#4
|
|
|
Remembered Posts: 5,055 From: Minneapolis, MN, USA |
Are you sure the workbook name is correct?
If the button is of the form variety, right-click on it and reassign the procedure to it. |
|
|
|
|
Dec 19 2003, 11:50 AM
Post
#5
|
|
|
UtterAccess Addict Posts: 122 From: Houston, TX |
Hey Nate
I actually managed to get into the code using the Step Into button, I had to fiddle with it for a while, but it is working now. I still have no Idea what happened. I tried the one you suggested but I couldn't track it to the correct macro, it was like all my code vanished. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 11:32 AM |