Excel Macro

  • Thread starter Thread starter John B
  • Start date Start date
J

John B

Hello to everybody.
When I open an Excel file I get a warning message regarding the presence of
a macro.
I accept and open the file, but I am not able to see any macro, or VBA
project with ALT+F11.

Can anyone of you (certainly more expert than a beginner like me) help to
discover how may I see this macro or VBA project in order to edit and
change.
If necessary I can send the file.

Many thanks and regards
John
 
John

If you have a workbook open, you will have a VBA Project.

Hit ALT + F11 then CRTL + R to open the Project Explorer.

There are several places macro code could be lurking, or you could just be the
victim of an empty module.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros

Gord Dibben Excel MVP
 
Many thanks for the answer,
now the warning message of a message is disappered.

However I have another question.
If I change the value of a cell, I receive another warning message: Value 0
it is not accepted. Minimun value is 5.

How my I edit this message?

Thanks again for your precious help.
Regards
John
 
/Data/ Validation

you can change all the validation properties there.
see Excel HELP on specifics.

in your case:
you'll want to edit the warning message.



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
Back
Top