$$Excel-Macros$$ Strange experience with Data validation

2012-07-27 Thread Rajesh Srinivasaraghavan
Hi folks, I have been using Excel 2010 for a few months now. Not until recently i noticed something strange with Data validation. Thought i should check with the group if this is a known issue or something specific to my system. When i created Data validation with "Allow list"& input two drop down

$$Excel-Macros$$ Review tab in Excel 2007

2011-02-02 Thread Rajesh Srinivasaraghavan
Hi, I have recently started using Excel 2007 and was previously with Excel 2003. I found the transition not very easy in terms navigating to the frequently used commands/functions. One observation i have is also that the 'Review' tab takes while to load unlike other tabs. Anyone has an idea on why

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

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

2010-07-22 Thread Rajesh Srinivasaraghavan
Hi Group, I need help in preventing unauthorized users from accessing my excel work book(s). Right now i have written the following vba code to achieve my objective. However, if some one were to choose to click 'Disable Macros', they can still access the contents of my file. Sub auto_open() UserN

$$Excel-Macros$$ Settings in Excel - Calculation - Manual/Automatic

2009-02-25 Thread Rajesh Srinivasaraghavan
Hi, I have come across instances where the calculation settings have got modified from Calculation to Manual. I found this issue when my colleagues ask me why there are not able to see results of a formula (when they drag the formula down). My colleagues had no clue about this settings & so i am su