LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Initializing a radio button on worksheet open event

I have two radio buttons created on Sheet1 of a 3-sheet workbook. I
have named the buttons opMemo and opNoMemo in the Properties of each.
When clicked, the buttons change the text of several cells on Sheet1
via _Click events. My problem is this: I want the opNoM button to be
checked when the workbook is opened.

I have this code under ThisWorkbook:

Private Sub Workbook_open()
Call opNoM
End Sub

The procedure opNoM is in a Module in the Project and looks like this:

Public Sub opNoM()
.... change the text in various cells on Sheet1
End Sub

This successfully sets up the sheet for the NoMemo mode, but if the
opMemo button was checked the last time the workbook was saved, it is
still checked when the workbook is opened. How do I ensure that the
opNoMemo button is checked when the workbook is opened?

Any help is greatly appreciated.
AllanK

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help re VBA for Worksheet Open Event LucyRB Excel Programming 5 January 12th 06 07:01 PM
How do I lock a radio button group if a N/A button is selected worry a lot Excel Discussion (Misc queries) 2 May 21st 05 08:33 PM
radio button on protected worksheet Rog[_4_] Excel Programming 3 December 29th 04 08:07 PM
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True Mcasteel Excel Worksheet Functions 2 October 29th 04 07:06 PM
Initializing variable vs. comand button M. Excel Programming 3 September 16th 03 10:27 AM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"