Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Macros 2003 into 2007
I have created a button (using the VB toolbox) in a 2003 version of excel. I
then saved the workbook and opened it up in excel 2007. When I click on the button it runs through the macro behind it. However when I right click on the button there is no functionality and so I can't see the code behind it. I have other macros written in 2007 and I can access them but not the 2003. So how can I view my original macro? Is there any way to view the Visual Basic Tool Bar in Excel 2007? TIA -- Lyndsey Wood www.totalsolutionmapping.com |
#2
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Macros 2003 into 2007
If the button is from the Control ToolBox then you have to be in design mode
for a right-click to pop up the button's context menu. This is the same as in earlier Excel versions. To go into design mode click the Design Mode button on the Developer tab. If the Developer tab is not visible turn it on via Excel Options, Popular. -- Jim "Lyndsey Wood" <nospamplease wrote in message ... |I have created a button (using the VB toolbox) in a 2003 version of excel. I | then saved the workbook and opened it up in excel 2007. When I click on the | button it runs through the macro behind it. However when I right click on | the button there is no functionality and so I can't see the code behind it. | I have other macros written in 2007 and I can access them but not the 2003. | So how can I view my original macro? Is there any way to view the Visual | Basic Tool Bar in Excel 2007? | | TIA | | -- | Lyndsey Wood | www.totalsolutionmapping.com | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enable macros in a 1997-2003 spreadsheet in Excel 2007 | Excel Discussion (Misc queries) | |||
I was using Excel 2007, now 2003 and my Macros won't work | Excel Worksheet Functions | |||
Excel 2003 Workbooks with macros (.xls) converted to Excel 2007 | Excel Discussion (Misc queries) | |||
Macros from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
Macros / VBA / Pivot Tables in 2003 & 2007 | Setting up and Configuration of Excel |