Macro Button Not working on Conversion from 97 to 2002

A

Abizar

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?
 
T

Tim Barlow

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
 
B

BrianB

Probably a button from the Controls toolbox - very bug ridden.
Use a button from Forms toolbox instead.

Regards
BrianB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top