Control Buttons frozen
It sounds like you'll have to replace those pictures with real buttons.
Is there any chance you saved the file as an xl95 file? xl97 was the first
version that used those controls from the control toolbox toolbar?
Any chance someone opened the file using a Mac? Macs don't use those controls,
either.
Tendresse wrote:
Hi all,
I have a problem with one of my spreadsheets. It contains quite a few
control buttons that used to be working perfectly for nearly a year.
Suddenly, they froze - as if they turned onto a picture. When I enter design
mode and try to get the 'Properties' of any of them, i only get the
'Properties' of the sheet they are in .. As if they are no longer recognised
as buttons. The macros are all fine .. and the codes in the Visual Basic
Editor are all intact. It's just the buttons lost their identity! I'm using
Excel 2003. Any one knows how i can fix this problem? Or do i have to
recreate all this buttons from scratch?
Many thanks
Tendresse
--
Dave Peterson
|