![]() Range("column_Custom_Number_1").EntireColumn.Hidden = False Wb.Worksheets("Admin").Range("Custom1_Attribute") = "Hide" Range("column_Custom_Number_1").EntireColumn.Hidden = True Range("column_fat").EntireColumn.Hidden = False Range("column_fat").EntireColumn.Hidden = True Range("column_weight").EntireColumn.Hidden = False Range("column_weight").EntireColumn.Hidden = True Range("column_max_hr").EntireColumn.Hidden = False Range("column_max_hr").EntireColumn.Hidden = True Range("column_avg_hr").EntireColumn.Hidden = False ![]() Range("column_avg_hr").EntireColumn.Hidden = True Range("column_calories").EntireColumn.Hidden = False Range("column_calories").EntireColumn.Hidden = True Range("cloumn_elevation_per_mile").EntireColumn.Hidden = False Range("cloumn_elevation_per_mile").EntireColumn.Hidden = True I think the code below won't work because it sets the ToggleButton value at startup when I need it to set when the form is loaded. So, does it make sense to set the togglebutton values on startup? I don't think so because everytime the user changes the 'preference' form the ToggleButton Value may change the next time the form is loaded (because they may have hidden a column). At no other time does the spreadsheet change the protection of a sheet. If he/she doesn't enable macros then all sheets are hidden except a sheet displaying a warning). The Sheet protection is a default to go off when the spreadsheet opens (and the user enables Macros. So, the only time I adjust the ToggleButton values is when I am loading the form. The form is a preferences form that allows the user to hide and display certain columns. The ToggleValue1.value is set when a form is submitted. The code you suggested above does work but I don't think it works in spreadsheet logic. Maybe it is being set and I just am not sure how to verify it. I presume that it's not being set because when I step through the macro and I hover over the "UserInterfaceOnly:=True" code I don't get any "pop-up" display. Range("column_calories").EntireColumn.Hidden = ToggleButton1.Value Is this not the place I should be putting the Sheet protection? Am I not doing this correctly? ![]() Protect Password:=SpreadsheetPassword, UserInterfaceOnly:=True This option is sometimes used by servers that only allow unencrypted connections.For Each wsSheet In ThisWorkbook.Worksheets CRAM-MD5: Username and password are encrypted.LOGIN and PLAIN: Username and password are not encrypted, but this is still secure if the connection is encrypted.If the connection type is unencrypted it will try only CRAM-MD5 Automatic: If the connection type is Encrypted, SSL or STARTTLS the automatic setting with try both LOGIN and PLAIN.You only need to enter something if your server uses non-default ports.Īuthentication type: The options are Automatic, LOGIN, PLAIN and CRAM-MD5. For SMTP they are 465 (SSL) and 587 and 25 (both for STARTTLS and unencrypted). For IMAP those are 993 (SSL) and 143 (STARTTLS and unencrypted). Port: If you leave it empty the default ports for the connection type will be used. Username, passwords and all email contents will be sent unencrypted and can be read by others e.g. Unencrypted: If possible, don't use this.STARTTLS: The connection will be started unencrypted and then "upgraded" to SSL (or TLS) before sending username and password.SSL: The connection will be SSL (or TLS) encrypted from the start.An unencrypted connection will not be used. Encrypted: Unibox will try both SSL and STARTTLS. ![]() Connection type: The options are Encrypted, SSL, STARTTLS and Unencrypted. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |