Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Tag Cloud
access acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory monitor motherboard network printer problem ram registry router security slow software sound toshiba trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless xbox
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: worksheet protection

Reply  
Thread Tools
scouse13's Avatar
Member with 127 posts.
 
Join Date: Oct 2009
19-Nov-2009, 05:15 PM #1
Solved: worksheet protection
is there a way using vba, that if a worksheet is protected,macro's,formula's and checkboxes(both form and activex still work.
my problem is two columns allow data entry and the others either have data in that i don't want changed or contain formula's which perform , an action on another cell, the same applies to the checkboxes which when returning a true value alter the colour of adjoining cells
computerman29642's Avatar
Computer Specs
Senior Member with 2,794 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
19-Nov-2009, 05:19 PM #2
If you are going to use VBA, then you would use code to unprotect the sheet, and re-protect the sheet obce the code has ran.

Do your current macros change data in the locked cells on the worksheet? If not, then even if the cells are locked, the formulas should still work.

Let us know exactly what it is you are trying to accomplish, and we can let you know the best way to achieve that goal.
__________________
Computerman29642
"Why so serious?....let's put a smile on that face" - The Joker

Last edited by computerman29642; 20-Nov-2009 at 01:41 PM..
scouse13's Avatar
Member with 127 posts.
 
Join Date: Oct 2009
03-Dec-2009, 03:24 PM #3
thanks computerman

yes i need the current macros to be able to change data in the locked cells
Reply

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 09:07 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.