pw1

  1. Trevor3007

    add yes no

    good evening, I use the following:- Sub Gencode() Static IsRandomized As Boolean Dim i As Integer, PW1 As String Dim cell As Range, PW As String With Sheets("code") ' Change Code to the name of the sheet this is to work on. .Unprotect If Not IsRandomized Then Randomize...
  2. Trevor3007

    run code from another worksheet but same workbook

    good evening, I use this code:- Sub Gencode() ActiveSheet.Unprotect Static IsRandomized As Boolean Dim i As Integer, PW1 As String Dim cell As Range, PW As String If Not IsRandomized Then Randomize: IsRandomized = True For Each cell In Range("b3:b199")...
  3. Trevor3007

    run a macro on sheet 1 but the macro is on sheet 3

    good morning, I want to run a macro that is on sheet 3 (sheet name is CODE ) from sheet 1 (sheet name is LT ) The code is:- Sub autocode() Static IsRandomized As Boolean Dim i As Integer, PW1 As String Dim cell As Range, PW As String If Not IsRandomized Then Randomize...
  4. C

    Changing Excel's default paste mode to values only, Grabbing text from cell stored in object

    Hello, I am attempting to make it so excel will only paste values when the command CTL + V is used. So, easy enough; I wrote this code and set the short cut key to CTL + V in the macro option window. Sub PasteValuesOnly() ' Prevents screen flashing during hide/unhide, turns off screen...
  5. Trevor3007

    run additional code in vb & yes/no

    Hi, I have this code that creates a random a password into a range:- Sub autocode() Static IsRandomized As Boolean Dim i As Integer, PW1 As String Dim cell As Range, PW As String If Not IsRandomized Then Randomize: IsRandomized = True For Each cell In...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top