Enable macros
 

I have a worksheet that I distrubute to employees, and some of them get a
message saying that "macros are disabled", and it does not allow them to
perform a function within the worksheet.

I know they can change their security settings, but the only problem is that
the function they want to perform is a simple calculation, and there are NO
macros within the workbook at all!

Enable macros
 

It could be that there are no macro's but that you have (completely empty)
modules. Remove these prior to distribution.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"richzip" wrote:

I have a worksheet that I distrubute to employees, and some of them get a
message saying that "macros are disabled", and it does not allow them to
perform a function within the worksheet.

I know they can change their security settings, but the only problem is that
the function they want to perform is a simple calculation, and there are NO
macros within the workbook at all!

Enable macros
 

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

richzip wrote:

I have a worksheet that I distrubute to employees, and some of them get a
message saying that "macros are disabled", and it does not allow them to
perform a function within the worksheet.

I know they can change their security settings, but the only problem is that
the function they want to perform is a simple calculation, and there are NO
macros within the workbook at all!

--

Dave Peterson