You should be able to use syntax like:


Code:
--------------------



With Sheets("Timesheet").buttons("Button 21")
.Height = 20
.Width = 40
End With
--------------------




for example.

I found it purely because I was looking for it! It's the only thing I
know of that would cause the symptoms you were describing, so I wrote
some code to output the names and locations of every button on the
sheet.

The code does not actually exist any more. The buttons had macros
assigned to them, but the macros have since been removed. It's an
occasional oddity that can occur with buttons and protected sheets -
usually seems to happen due to deleting cells that the button was
located in.


Isis;731903 Wrote:

aflatoon wrote in
:

Sheets("Timesheet").buttons("Button 21").delete

aflatoon, thanks very much for taking the time to find this.

If I may ask a couple of questions;

Can I just enlarge this button so I can see it ? I cannot seem to find
the code syntax to do that.

How did you find the button ?

Why doesn't the code on the button how up anywhere in teh code or
macro
editors ?

Trying to learn something here :-)

Thanks for the help


--
aflatoon

Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile: http://www.thecodecage.com/forumz/member.php?u=1501
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=205117

http://www.thecodecage.com/forumz