Hi friends,
I want to allow Insert Row option with below code. Can you please edit below code....
Please Login or Register to view this content.
Hi friends,
I want to allow Insert Row option with below code. Can you please edit below code....
Please Login or Register to view this content.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Is it right ?Please Login or Register to view this content.
I think you meant to try it and report back on whether it worked for you or not.
With above code I am able to insert row, but copy and formulas past option not working
Can you please give code for formulas past option.
You cannot PASTE into a locked cell on a protected sheet. This means before the sheet is protected, you need to first unlock the protection flag on the cells where you want PASTE to work.
As for being able to PASTE into an inserted row, keep in mind that newly inserted rows inherit their characteristics from the row/cells above. So as long as the inserted row is below an unprotected row you will be able to paste into it as well.
Thank you Friend......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks