LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
TANDEX
 
Posts: n/a
Default How to lock worksheet formatting?

Is there a way lock worksheet formatting? Excel 2002 workbook, i use spreadsheet to prepare invoices, new ones based on previous spreadsheet.

I need prevent from invoice from changing (lock cells, i.e. keep formatting without changes), but worker still need be able fill the data into cells, then save invoice.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
xls worksheet formatting a single cell Archer------------> Excel Discussion (Misc queries) 1 April 30th 05 07:25 PM
Why color formatting not showing on worksheet? Mary-Lou New Users to Excel 2 March 9th 05 10:17 AM
Formatting a worksheet for data entry DV in Texas Excel Worksheet Functions 2 March 6th 05 07:48 PM
How can I lock a number of cells within a worksheet? IGA Excel Discussion (Misc queries) 4 February 25th 05 01:38 AM
How to lock a worksheet and enable the PivotTable refresh data opt Saariko Excel Worksheet Functions 3 October 31st 04 03:02 PM


All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"