Active Directory, AS/400, Business Intelligence, CIO, Cisco, Database, DataCenter, DB2, Desktops, Development, Exchange, Exchange 2003, Exchange 2007, Hardware, iSeries, Linux, Lotus Domino, Lotus Notes, Management, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP VIEW ALL TAGS
My spreadsheet is "read only" accessed by others in my business. Certain columns are locked. I'd like users to be able to copy and insert new copied rows, but when the sheet is protected copy and insert copied rows is not allowed. How do I allow this when sheet is protected?