can't record a new macro or insert module in editor

D

Douglas Allen

When i try to record a new macro it tells me it is unalbe
to record. When i go into the VB editor and go to the
insert menu all the items are greyed out so I can't
select module and so create a new macor that way. I have
changed the security off from high (tried on both medium
and low). Does anybody know why I can't make new macros?
Douglas Allen
 
G

Gord Dibben

Douglas


Unfortunately the "Unable to record" message has several potential causes.

Suggest you wander through these google search results dealing with this
issue. Perhaps something will do the trick.

The Personal.xls file seems to be high on the list.

http://snipurl.com/826z

Gord Dibben Excel MVP
 
Top