LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default lock a workbook until certain cells are filled

I have a workbook that I would like to have certain cells filled (as in:
name, address, phone, etc) before you are able to just start entering other
information. what would be the direction to use? a macro? or an excel
function. i found one example where cells had to be filled before you were
allowed to save the workbook. that involved writing some code at the location
of the excel sign next to the file button.
I already have a macro to do a "save as" using the cells, however, the cells
do not have to be filled to use the function. (it just defaults to a date).
i don't know enough about VBA to write something on my own. i'm getting
pretty good at copying other examples and applying them to my application.
thx
 
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
Lock cells in a shared workbook Jennifer Excel Discussion (Misc queries) 1 December 14th 09 08:45 PM
Filled cells dont appear as filled SMILLS Excel Discussion (Misc queries) 6 October 18th 07 05:28 PM
Lock cells in shared workbook Raj Excel Worksheet Functions 0 December 16th 06 01:51 AM
lock cells until one cell is filled Debbie Excel Programming 2 May 23rd 06 06:39 PM
Can i add up all green filled cells in a workbook? Richelle Excel Worksheet Functions 1 November 30th 05 05:40 AM


All times are GMT +1. The time now is 06:28 PM.

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"