2 Label Options - Forms Object vs Control Box Object
 

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

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

2 Label Options - Forms Object vs Control Box Object
 

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

"Jacob Skaria" wrote:

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

2 Label Options - Forms Object vs Control Box Object
 

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

"Jacob Skaria" wrote:

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