| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button Not working on Conversion from 97 to 2002
Converting from 97 to Excel 2002. I had created a button
to run a macro in Excel 97. When I open the file in Excel 2002, that button has become much larger and hides all the data on the worksheet. It still runs the macro, but I cannot resize the object or delete it. I tried right clicking, bu that did not work. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Button Not working on Conversion from 97 to 2002
From Excel, try opening the Visual Basic toolbar (right-
click on the top menu bar and select Visual Basic). On the VB toolbar, click on the "Design Mode" icon. Then try re-sizing the button. Click the icon again when done. Tim -----Original Message----- Converting from 97 to Excel 2002. I had created a button to run a macro in Excel 97. When I open the file in Excel 2002, that button has become much larger and hides all the data on the worksheet. It still runs the macro, but I cannot resize the object or delete it. I tried right clicking, bu that did not work. Any suggestions? . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Button Not working on Conversion from 97 to 2002
Probably a button from the Controls toolbox - very bug ridden.
Use a button from Forms toolbox instead. Regards BrianB ----------------------------------------------------- "Abizar" wrote in message ... Converting from 97 to Excel 2002. I had created a button to run a macro in Excel 97. When I open the file in Excel 2002, that button has become much larger and hides all the data on the worksheet. It still runs the macro, but I cannot resize the object or delete it. I tried right clicking, bu that did not work. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying a macro to a command button, Excel 2002 | Excel Discussion (Misc queries) | |||
| Excel 2002 error in conversion | Excel Discussion (Misc queries) | |||
| Excel 2002 Macro Run button disabled? | Excel Programming | |||
| HELP! Button/Macro or Function has stopped working! | Excel Programming | |||
| macro written in Excel 2000 not working in Excel 2002 | Excel Programming | |||
Linear Mode
