Code writing assistance in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have received input from Paul B., Gord and Peo on this matter, but I am a total novice with respect to macro functions and writing code

I need some help to try and accomplish my task. Here are the facts

1. I have an Excel spreadsheet that is password protecte
2. Users may enter text in cells and text boxes
3. I need to create a macro that will allow the user to spell check cells and text boxes, without seeing or having to input the password

I tried to cut and paste the three sugestions I received earlier into VBA, but I kept getting error messages. Any assistance would be most appreciated.
 
Hi Ron..........

For lack of a more specific answer, you might check out Chip Pearson's page
( http://www.cpearson.com/excel/topic.htm )or other MVP pages for VBA
tutorials........

Vaya con Dios,
Chuck, CABGx3


Ron Green said:
I have received input from Paul B., Gord and Peo on this matter, but I am
Click to expand...
a total novice with respect to macro functions and writing code.
I need some help to try and accomplish my task. Here are the facts:

1. I have an Excel spreadsheet that is password protected
2. Users may enter text in cells and text boxes.
3. I need to create a macro that will allow the user to spell check cells
Click to expand...
and text boxes, without seeing or having to input the password.
I tried to cut and paste the three sugestions I received earlier into VBA,
Click to expand...
but I kept getting error messages. Any assistance would be most
appreciated.
 
Back
Top