Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Locking Cells & Protecting Excel Sheets via VBA
Ok I'm using Excel '97 & I've got a spreadsheet that is filled out by means of a form dialogue. Now after the user has finished with the form entries are placed in the spreadsheet. I need to lock some of the cell that have been entered & leave others free for editing manually I was trying to do...- RougeDev
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Locking Unlocking Cells Via VBA
Ok I'm using Excel '97 & I've got a spreadsheet that is filled out by means of a form dialogue. Now after the user has finished with the form entries are placed in the spreadsheet. I need to lock some of the cell that have been entered & leave others free for editing manually I was trying to do...- RougeDev
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Resource Allocation, can I do it by groups??
I'm working on project that involves a large amount of manufacturing. What I'd like to do is allocate resources to a task on a group basis. eg Add the welders to the weld girders task. Give the numbers in each resource group allocating on an individual basis would be pain Anybody got any...- RougeDev
- Thread
- Replies: 7
- Forum: Microsoft: Project
-
Query Access from another MS application
Hi I need to pull data from a MS Access database for use within a combo-box inside an Excell spreadsheet. How do I instantiate the ADO I need to query?? & Then do I just use a querydef object to query the ADO??? Am just teaching myself VBA so am a littel lost Thanks Gavin- RougeDev
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
