RE: $$Excel-Macros$$ Re: VBA Code for inserting a row in table in protected sheet

2012-07-06 Thread Asa Rossoff
Hi B Sharma, One option not mentioned is to protect the sheet from VBA using the UserInterfaceOnly option. With this option, your VBA code does not have to unprotect the sheet - it has untethered access. The sheet will be protected from direct interaction with the user only. For that, you co

Re: $$Excel-Macros$$ Re: VBA Code for inserting a row in table in protected sheet

2012-07-06 Thread ChilExcel
B Sharma Please see attached file ,I think is what you need Chilexcel 2012/7/6 ChilExcel > B Sharma > > Please see attached file ,I think is what you need > > > Chilexcel > 2012/7/6 B Sharma > >> Dear Friend Noorain, >> Thanks for your quick reply... >> >> I tried this but failed, I was una

Re: $$Excel-Macros$$ Re: VBA Code for inserting a row in table in protected sheet

2012-07-06 Thread ChilExcel
B Sharma Please see attached file ,I think is what you need Chilexcel 2012/7/6 B Sharma > Dear Friend Noorain, > Thanks for your quick reply... > > I tried this but failed, I was unable to insert rows in the table. > I have attached a file for your reference too. > > Please see and help. > > B