View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 2 Label Options - Forms Object vs Control Box Object

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

If this post helps click Yes
---------------
Jacob Skaria


"Awrex" wrote:

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!!!!!