Re: $$Excel-Macros$$ BeforeSave - Enabling Macros

2010-02-05 Thread Sanjoy Nath
Dear Paul, If you set the important calculations with Macro , then people will become bound to enable macros.That will help you to achieve your motive. Sanjoy On Thu, Feb 4, 2010 at 9:44 PM, PWS p...@twelve.me.uk wrote: Interesting situtaion which I sure others have come across before. I

$$Excel-Macros$$ BeforeSave - Enabling Macros

2010-02-04 Thread PWS
Interesting situtaion which I sure others have come across before. I cannot think of a solution, I wonder if anyone else has or can? I have the requirement to not allow a workbook to be saved if a user has not entered information into a specified cell. I thought that is easy I will write a

Re: $$Excel-Macros$$ BeforeSave - Enabling Macros

2010-02-04 Thread Paul Schreiner
: PWS p...@twelve.me.uk To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thu, February 4, 2010 11:14:04 AM Subject: $$Excel-Macros$$ BeforeSave - Enabling Macros Interesting situtaion which I sure others have come across before.  I cannot think of a solution, I wonder if anyone else has

RES: $$Excel-Macros$$ BeforeSave - Enabling Macros

2010-02-04 Thread Ulisses Flores
de fevereiro de 2010 13:14 Para: MS EXCEL AND VBA MACROS Assunto: $$Excel-Macros$$ BeforeSave - Enabling Macros Interesting situtaion which I sure others have come across before. I cannot think of a solution, I wonder if anyone else has or can? I have the requirement to not allow a workbook

Re: $$Excel-Macros$$ BeforeSave - Enabling Macros

2010-02-04 Thread Phillip Swanepoel
Sent: Thu, February 4, 2010 11:14:04 AM Subject: $$Excel-Macros$$ BeforeSave - Enabling Macros Interesting situtaion which I sure others have come across before.  I cannot think of a solution, I wonder if anyone else has or can? I have the requirement to not allow a workbook to be saved

Re: $$Excel-Macros$$ BeforeSave - Enabling Macros

2010-02-04 Thread PWS
Thanks Paul. I did understand the reasoning that the macroing language is capable of writing vairuses and other 'nasty' things. I like your work around. Thanks again. -- -- Some important links for excel users: 1.