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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2002 Protection & Macros

Status
Not open for further replies.
GreyBox

GreyBox

Programmer
Sep 13, 2002
5
GB
When my Excel 2000 macros are run on Excel 2002, worksheet protection acts in ways I don't appreciate.

I want to be able to change formats in some cells from VBA code, but Excel seems to only provide flexibility in the protection such that specified users can change certain ranges. Also when I set 'User Interface Only=True' in the worksheet protection in my VB code, Excel 2002 still flags an error when my code changes a cell format on an unprottected cell.

How do I lose the protection error when my macros run without unprotecting the worksheets totally? TIA. :)
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
795
strongm
strongm
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
465
mikrom
mikrom
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
369
remeng
remeng
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
934
remeng
remeng
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
536
huiettcm
huiettcm

Part and Inventory Search

Sponsor

Back
Top