2 Label Options - Forms Object vs Control Box Object

[Awrex]

Hi -

Using Excel 2003

So I have a worksheet that I use as a scheduling calendar and I'm currently
using the VBA label object to span across days to show an activity. I love
this label, it allows me to center the text and change the label appearance
as needed. However, I always get that damn macro prompt when I open the file,
which I know it's because I use the control box label.

I do have the forms label object option, but that one has no features
whatsoever... It's like going from a car to a skateboard.

Am I just stuck with one or the other??? Excel upgrade not an option, as
it's a company pc.


Thanks!!!!!

 

[Jacob Skaria]

Set the Security level to low in (Tools|Macro|Security).

If this post helps click Yes

 

[Awrex]

Yeah.. that would be fine for just me, though this is a public document.

 

[Awrex]

Also.. I know I could just make some image to use, but that is only a short
term solution...