Password Protect A Toggle Button
May 19, 2009
I've got a toggle button that is clicked to hide the score details (using a macro). I need this button to have some sort of password protection because only I should be able to see the score!
I've tried to use the '.protect .unprotect' function, but its not doing exactly what I want it to so Im not sure I even need it there!
Here is my code..
Option Explicit
Private Sub ToggleButton1_Click()
Sheet1.Unprotect
With Range("78:88").EntireRow
.Hidden = Not .Hidden
End With
Sheet1.Protect
End Sub
View 9 Replies
ADVERTISEMENT
Mar 5, 2008
I want to password protect a command button, so that when a user clicks the button, it prompts them for a password before the button is enabled.
View 3 Replies
View Related
Jan 12, 2007
I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.
Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub
View 3 Replies
View Related
Jul 12, 2012
My boss has come to me and asked how does she get her file to go back to the way it was before, she had a password on the file but you used to be able to click on a button that said "Read only" this button no longer appears and i am unable to get it back. I still get the password box pop up but it is smaller and does not contain the read only button.
View 3 Replies
View Related
Jul 21, 2014
I have made an excel sheet for multiple choice questions, in which person needs to click on submit button after completing with the test & pop up will say "Your score is__". Now, I want to want to add one more button named "Reset". I want below :
results:
1. Person should not be able to make any changes after clicking on "Submit" button.
2. If one tries to click on "Reset" button, it should ask for password.
3. After keying password for "Reset" button, all questions should be reset so that next person can give test.
I have attached an example excel sheet for reference : DoM1.xlsm
View 2 Replies
View Related
Jan 17, 2013
Some sensitive data is held on worksheets that are used by people that do not have access to see the data.
It would be most convenient to keep the data in these worksheets but hide it from view of the users.
Is there a way to password protect a users ability to unhide a column?
View 2 Replies
View Related
Nov 11, 2011
I have a togglebutton for an excel sheet in use for scoring psychological tests. When pressed, the button higlights the cells where a raw score is inserted.
What I need is a code to higlight the togglebutton when pressed, eg. green (colorindex 4). The button is white. How to do this?
Below is the code, It has more lines than needed, but it works.
Private Sub ToggleButton1_Click()
'FKV TOGGLE'
ActiveSheet.Unprotect "manisk"
If ToggleButton1 Then
[Code] ........
View 2 Replies
View Related
Aug 13, 2008
I have read several articles saying using a command button as a toggle button can't be done but some articles have said it is possible using the state properties.
.State = msobuttondown
.State = msobuttonup
Is there any way to combine this with the onaction property so that when you press the button, it stays down and activates a macro then when you press it again it pops back up and activates another macro.
View 8 Replies
View Related
Feb 23, 2008
I'm looking for a way to have mutually exclusive toggle buttons (i.e. only one can be selected at a time) embedded in a worksheet. It is possible with radio buttons but they won't serve my needs.
View 5 Replies
View Related
Apr 7, 2014
Is there a way to get a sound toggle button on excel?
What I need is a button to turn the sound alerts on and off on my spreadsheet. Ideally I'd like a button that either changed an image to the speaker image when on and the speaker image with line through it when off. Is that possible?
If not, is it possible to have a button that just says: "Sound:ON" or "Sound:OFF"?
I guess it could be done with tick boxes, or drop down options.
View 4 Replies
View Related
Mar 26, 2014
I have the code below for creating a stopwatch in excel. I was trying to see if there is a way to change this code to assign it to a toggle button so if you hit one part the stopwatch would start and then the other it would stop.
[Code] ....
View 4 Replies
View Related
Feb 11, 2009
I wanted to know how do I keep a toggle button in the on(ture) position after I close the userform? How do I keep the toggle button off(false) positoin after I close the userform? In order words, once I run my macro again, I want it to remain in memory that my toggle button was in the on(true) or off(false)?
For example,I have an application that I am developing which involves some what-if analysis for some projects. There is a command button located on my worksheet. After the command button is clicked, I have include some toggle buttons on a userform for all of the various projects. If I assume that sine projects will not be used, I click the associated toggle buttons. This puts them in the on(true) position. After I close the userform and reclick the command button, my toggle buttons are all back in the off(false) position.
View 5 Replies
View Related
Jul 27, 2009
it's possible to use this macro code in a toggle to perform this action when it's true and when the toggle is click again it can undo it.
This macro does lookups and finds the max on sets of value when it is run and i was wondering if by clicking the button again it can undo what it placed in the cells.
View 4 Replies
View Related
Jan 24, 2008
I need a macro for button1. The name of button one is "on" when clicked I want it to put an "X" in A1 and then change the button name to "off" When clicked again I want it to delete the "X" in A1 and change the name back to "on". When clicked again it repeats the same process.
View 7 Replies
View Related
Dec 9, 2008
is it possible to password protect a tab (worksheet) within a multiple worksheet file.
View 9 Replies
View Related
Mar 27, 2014
Is there a way to change the text on a toggle button in the code below? Basically I would like for the toggle button to begin with the word "START" on it and then when clicked changed to the word "STOP". Of course then when the user clicks on "STOP" it changes back to "START".
View 3 Replies
View Related
Sep 11, 2009
I have a sheet in which I am using freeze panes to keep the header section always visible. I would like to be able to add a toggle button with a macro to the sheet to allow the user to turn the existing freeze panes on/off at will, without the need to navigate the menu bar itself. So far I have not been able to find any info on if/how this may be possible. If anyone has any experience controlling freeze panes via macros, etc.
View 3 Replies
View Related
Nov 4, 2011
ToggleButton? I have made this Macro work
Sub group()
'
Dim i As Integer
Sheets("Operating Income Trending (LOC)").Select
For i = 53 To 2 Step -1
If Cells(7, i) = "" Then
Sheets("Operating Income Trending (LOC)").Columns(i).EntireColumn.Hidden = True
End If
Next i
End Sub
And when i tried to put it into a togglebutton like below:
Private Sub ToggleButton1_Click()
Select Case ToggleButton1.Caption
Case "Group"
Dim i As Integer
Sheets("Operating Income Trending (LOC)").Select
[Code] .........
Then instead of hiding all the blank columns, it hides almost all the columns, leaving some that are supposed to hide. i could not figure out why as it worked fine as individual macro.
View 2 Replies
View Related
Nov 15, 2011
I have 15 toggle buttons that are each tied to a unique value. A toggle button identifies the value as either Active or Inactive. I then want to add a command button that will produce the product of all the Active toggle button values.
For very few togglebuttons I can use a code similar to the following (adjusting for the number of buttons)
Code:
Private Sub CommandButton1_Click()
If ToggleButton1.Value = False Then
Sheets ("CTG Calc").Range("e50 = Sheets("CTG Calc").Range("E47") * Sheets("CTG Calc").Range("E48)
Else
Sheets("CTG Calc").Range("E50) = Sheets("CTG Calc").Range("E47")
End If
End Sub
However, when I get more than just a couple togglebuttons it becomes very unwieldy to have multple If then statments for a True/False option for all 15 buttons. I know there is an easier way to do this with some kind of array function that will look at each toggle button separately anf if the togglebutton value is false will generate the product of all false togglebuttons and ignore the value of all true toggle buttons.
View 6 Replies
View Related
Dec 23, 2011
I have a userform with 70 toggle buttons, the buttons are arranged in 7 columns and 10 rows, hence I named each button c1r1 to c7r10.
The button captions will change, so I want to take the captions from cell contents: worsheet 'Buttons' and the range A1:A70
I can do this long hand...
c1r1.Caption = Sheets("Buttons").Range("A1")
c1r2.Caption = Sheets("Buttons").Range("A2")
.....
c1r10.Caption = Sheets("Buttons").Range("A10")
c2r1.Caption = Sheets("Buttons").Range("A11")
c2r2.Caption = Sheets("Buttons").Range("A12")
unitl I get to
c7r10.Caption = Sheets("Buttons").Range("A70")
I guess a loop would be better. Here's my code that does not work..
I was just going to insert word 'works' for now until I get the loop to work.
I'd also have to get a loop inside this loop, ie when the column number is 1, it needs to loop through the rows numbers, before it loops to column 2.
I guess I might be able to do that, but I fall at the first hurdle, I get Error 424, object required. I guess it does not like 'buttonaddress.caption'
Do I need to declare or dim 'buttonadress'?
buttoncoladdress = 1
buttonrowaddress = 1
Do Until buttoncoladdress = 7
buttonaddress = "c" & buttoncoladdress & "r" & buttonrowaddress
buttonaddress.Caption = "works"
buttoncoladdress = buttoncoladdress + 1
Loop
View 3 Replies
View Related
Jan 8, 2012
I dont like the way the toggle button looks. So i wanted to create a button that when pressed would recognized if row 19 was hidden or not hidden..
Then if it was already hidden it would unhide the row 19
or if it was not hidden it would hide the row 19 when clicked
Is this possible via a macro?
View 1 Replies
View Related
Aug 14, 2007
Is there a way to insert a toggle button into a custom tool bar?
View 4 Replies
View Related
Mar 15, 2007
i want to protect or give password in only one cell plz let me know how can i do this reply me as soon as possible
i m in touble to give password in one cell i want when i try to put any thing on that cell it will
View 11 Replies
View Related
Nov 30, 2009
I need to make my spreadsheet require a password to open. How do I do this?
View 2 Replies
View Related
Oct 24, 2007
I currently have a macro which i run by selecting tools, macro, macro and then selecting the one i want and pressing run. if i press run I want a box to appear asking me to input a password and if password matches then run that specific macro, can this be done
View 2 Replies
View Related
Oct 22, 2008
Is there a way to password protect the macro code, so that someone can't open the coding?
View 4 Replies
View Related
Feb 5, 2009
I am seeking a method of password protecting worksheets in a workbook. The users would all start on a sheet that has their names (A1 - A10) next to their names would be where they type in their password (B1 - B10). If their password is correct their assigned worksheet (Worksheet2) would be unlocked for editing.
View 11 Replies
View Related
May 12, 2009
1) I need to have code to protect the sheet that my user form is writing to. In other words, when the information from the user form is populated to the sheet, I want that sheet protected by a password that I set where I can unlock it, but no one else can.
2) I need to protect my VBA code with a password, I do not know how to do this, I have looked everywhere. I do however think this is something simple and I will kick myself once I find out where it is.
View 6 Replies
View Related
Jan 11, 2010
I have a workbook that contains a series of macros designed to compare various reports and spit out a report. I don't want my users to have to insert a password, but I want to keep my workbook protected. I've already protected the macros in the VBA Properties, so those are pretty safe, but the worksheets in the workbook are susceptible to changes that will hose my macros.
Setting the workbook to "Read Only" in Properties on our shared drive helps, but any user can change that at will. Within Excel, going to Options, Security, I can set a password so no-one can modify that workbook, but that pops up a password box when they open the workbook. I'd like to NOT have the password box pop up unless I need to make changes. Is there a way to do that? I've looked on the internet but can't find a solution on this one.
View 5 Replies
View Related
Jan 21, 2010
the user is prompted with a password inputbox to both protect and unprotect my worksheet named: Data. I am using Excel 2003.
View 3 Replies
View Related
