Re: $$Excel-Macros$$ Preventing unauthorized access for your excel files

2010-07-22 Thread Rajesh Srinivasaraghavan
Thanks Dave. I will try this! Regards Rajesh On Thu, Jul 22, 2010 at 6:37 PM, Dave Bonallack wrote: > Hi, > Create a new sheet. On that, in large font, enter "Macros must be enabled > to use this workbook." > Create a workbook close event macro that makes all sheets xlveryhidden > except the new

RE: $$Excel-Macros$$ Preventing unauthorized access for your excel files

2010-07-22 Thread Dave Bonallack
Hi,Create a new sheet. On that, in large font, enter "Macros must be enabled to use this workbook."Create a workbook close event macro that makes all sheets xlveryhidden except the new sheet.Create a workbook open event macro that hides the new sheet and unhides all the others.If the macros are