The link below is to a spreadsheet that does a number of things I like.
One being that the radial buttons return a numeric value rather then T/F.

Part of the problem with the sheet though is that it is protected.
It also says it has an Excel 4 macro that must run on startup.

Anyone know how to disable or delete the macro that runs?
How do I reporduce these option buttons that return numbers rather then True
and False?
I'm hoping to be able to total the score at the end...

http://www.mccsa.com/Temp/copy.zip

Any ideas of help would be apprciated.

Kelvin

These are option buttons from the forms toolbar.

for the Excel 4 macro sheet, this was created to use the template wizard.
It you want to divorce it from the template wizard, open this workbook and a
new workbook. go to the vbe and insert a module in the new workbook. Paste
in this code

Sub abc()
For Each sh In ActiveWorkbook.Sheets
Debug.Print sh.Name
sh.Visible = xlSheetVisible
Next
End Sub


make the copy.xls workbook the activeworkbook, then run that macro. go into
tools=Options and under the view tab, select Sheet Tabs in the lower right.

You should see to new sheets plus Sheet2. These are your macro sheets. Go
to each one and select Insert=Name, select the Auto_Open name and delete
it.

Delete the macro sheets, save the workbook.

--
Regards,
Tom Ogilvy


"Kelvin Beaton" <kelvin at mccsa dot com wrote in message
...
The link below is to a spreadsheet that does a number of things I like.
One being that the radial buttons return a numeric value rather then T/F.

Part of the problem with the sheet though is that it is protected.
It also says it has an Excel 4 macro that must run on startup.

Anyone know how to disable or delete the macro that runs?
How do I reporduce these option buttons that return numbers rather then
True and False?
I'm hoping to be able to total the score at the end...

http://www.mccsa.com/Temp/copy.zip

Any ideas of help would be apprciated.

Kelvin

Hi Tom

Thanks for the help!
I seem to have the macros out of the way.

I'm down to the password needing to be recovered.
Do you know of any free options for cracking this?

Thanks for your help!

Kelvin


"Tom Ogilvy" wrote in message
...
These are option buttons from the forms toolbar.

for the Excel 4 macro sheet, this was created to use the template wizard.
It you want to divorce it from the template wizard, open this workbook and
a new workbook. go to the vbe and insert a module in the new workbook.
Paste in this code

Sub abc()
For Each sh In ActiveWorkbook.Sheets
Debug.Print sh.Name
sh.Visible = xlSheetVisible
Next
End Sub


make the copy.xls workbook the activeworkbook, then run that macro. go
into tools=Options and under the view tab, select Sheet Tabs in the lower
right.

You should see to new sheets plus Sheet2. These are your macro sheets.
Go to each one and select Insert=Name, select the Auto_Open name and
delete it.

Delete the macro sheets, save the workbook.

--
Regards,
Tom Ogilvy


"Kelvin Beaton" <kelvin at mccsa dot com wrote in message
...
The link below is to a spreadsheet that does a number of things I like.
One being that the radial buttons return a numeric value rather then T/F.

Part of the problem with the sheet though is that it is protected.
It also says it has an Excel 4 macro that must run on startup.

Anyone know how to disable or delete the macro that runs?
How do I reporduce these option buttons that return numbers rather then
True and False?
I'm hoping to be able to total the score at the end...

http://www.mccsa.com/Temp/copy.zip

Any ideas of help would be apprciated.

Kelvin

http://www.mcgimpsey.com/excel/removepwords.html

--
Regards,
Tom Ogilvy


"Kelvin Beaton" <kelvin at mccsa dot com wrote in message
...
Hi Tom

Thanks for the help!
I seem to have the macros out of the way.

I'm down to the password needing to be recovered.
Do you know of any free options for cracking this?

Thanks for your help!

Kelvin


"Tom Ogilvy" wrote in message
...
These are option buttons from the forms toolbar.

for the Excel 4 macro sheet, this was created to use the template wizard.
It you want to divorce it from the template wizard, open this workbook
and a new workbook. go to the vbe and insert a module in the new
workbook. Paste in this code

Sub abc()
For Each sh In ActiveWorkbook.Sheets
Debug.Print sh.Name
sh.Visible = xlSheetVisible
Next
End Sub


make the copy.xls workbook the activeworkbook, then run that macro. go
into tools=Options and under the view tab, select Sheet Tabs in the
lower right.

You should see to new sheets plus Sheet2. These are your macro sheets.
Go to each one and select Insert=Name, select the Auto_Open name and
delete it.

Delete the macro sheets, save the workbook.

--
Regards,
Tom Ogilvy


"Kelvin Beaton" <kelvin at mccsa dot com wrote in message
...
The link below is to a spreadsheet that does a number of things I like.
One being that the radial buttons return a numeric value rather then
T/F.

Part of the problem with the sheet though is that it is protected.
It also says it has an Excel 4 macro that must run on startup.

Anyone know how to disable or delete the macro that runs?
How do I reporduce these option buttons that return numbers rather then
True and False?
I'm hoping to be able to total the score at the end...

http://www.mccsa.com/Temp/copy.zip

Any ideas of help would be apprciated.

Kelvin

Thanks!

Kelvin

"Tom Ogilvy" wrote in message
...
http://www.mcgimpsey.com/excel/removepwords.html

--
Regards,
Tom Ogilvy


"Kelvin Beaton" <kelvin at mccsa dot com wrote in message
...
Hi Tom

Thanks for the help!
I seem to have the macros out of the way.

I'm down to the password needing to be recovered.
Do you know of any free options for cracking this?

Thanks for your help!

Kelvin


"Tom Ogilvy" wrote in message
...
These are option buttons from the forms toolbar.

for the Excel 4 macro sheet, this was created to use the template
wizard. It you want to divorce it from the template wizard, open this
workbook and a new workbook. go to the vbe and insert a module in the
new workbook. Paste in this code

Sub abc()
For Each sh In ActiveWorkbook.Sheets
Debug.Print sh.Name
sh.Visible = xlSheetVisible
Next
End Sub


make the copy.xls workbook the activeworkbook, then run that macro. go
into tools=Options and under the view tab, select Sheet Tabs in the
lower right.

You should see to new sheets plus Sheet2. These are your macro sheets.
Go to each one and select Insert=Name, select the Auto_Open name and
delete it.

Delete the macro sheets, save the workbook.

--
Regards,
Tom Ogilvy


"Kelvin Beaton" <kelvin at mccsa dot com wrote in message
...
The link below is to a spreadsheet that does a number of things I like.
One being that the radial buttons return a numeric value rather then
T/F.

Part of the problem with the sheet though is that it is protected.
It also says it has an Excel 4 macro that must run on startup.

Anyone know how to disable or delete the macro that runs?
How do I reporduce these option buttons that return numbers rather then
True and False?
I'm hoping to be able to total the score at the end...

http://www.mccsa.com/Temp/copy.zip

Any ideas of help would be apprciated.

Kelvin