protection option

  • Thread starter Thread starter nowfal
  • Start date Start date
N

nowfal

Hi,
I am using office 2003 in my home computer and office 98 in office,
i would like to know, is there any add-in for 98 i can use for
protection selection just like in 2003. which is very useful.
thanks and regards
nowfal
 
The granular level of protecting the worksheet (allowing the user to edit
ranges) was added with xl2002.

Before xl2002, you could write macros that would do what you want.

Usually, the code would unprotect the worksheet, do the specific changes, then
reprotect the worksheet.
 
Hi dave,
is there any further information, where do i get those
macros.any eralier threads ?
thanks
nowfal
 
Millions of threads out there!

The bad news is that most people ask specific questions requiring specific
answers. I'd be pretty surprised if you could find the ones you wanted in
google--but you'll find lots of close ones.

Once you see a few, you'll see what you want to do--but until then, I would
decide on my first project (delete the selected row???), then record a macro
when you unprotected the worksheet, deleted that row, then reprotected the
worksheet.

Then you'll see what needs to be done. After a bit of playing around, you'll be
able to add restraints to your code--only certain rows can be deleted
(maybe???).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

And you'll want to give the user a way to run your code.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top