 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / January 2008Can't insert row
I downloaded a free cashflow template and wanted to add more rows to it. I went to 'Insert' in the toolbar menu, but 'row' was greyed out, along with 'cells' & 'columns'. Any advice appreciated. Thanks. Many templates are designed with Protection applied in order to *prevent* modification - intentional or otherwise:-) If it can be unprotected you'll find the command in the Tools menu but it may require a password. It's also possible that the template may have other programmatic aspects that disable certain commands or features, but in a template that's offered free it's unlikely the designer went to that extent.  SignatureHTH |:>) Bob Jones [MVP] Office:Mac >I downloaded a free cashflow template and wanted to add more rows to it. I > went to 'Insert' in the toolbar menu, but 'row' was greyed out, along with > 'cells' & 'columns'. > > Any advice appreciated. Thanks. On 1/10/08 9:35 AM, in article C3ABDE39.4873%teflon@privateFEmail.me.uk, > I downloaded a free cashflow template and wanted to add more rows to it. I > went to 'Insert' in the toolbar menu, but 'row' was greyed out, along with > 'cells' & 'columns'. > > Any advice appreciated. Thanks. The worksheet was protected. Try unprotect it. If it has a password, you'll have to get it from the author or distributor. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom > On 1/10/08 9:35 AM, in article C3ABDE39.4873%teflon@privateFEmail.me.uk, > [quoted text clipped - 6 lines] > The worksheet was protected. Try unprotect it. If it has a password, you'll > have to get it from the author or distributor. Or do a Google search for "password.xla" -- a nice little add-in that gets around the stupid Excel password. :-) SignatureTeam EM to the rescue! http://www.team-em.com Many thanks for the replies. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.