control buttons

  1. R

    Macro to change text in macro on control button in workbook?

    I have inherited a process which has a template workbook with Macro buttons so users can move to specific sheets. The template has been used to create approx 700 files. I have been making some amendments to the template, which has included changing one of the worksheet names - this means one...
  2. T

    How can I protect my control buttons

    <!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Version>14.00</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello I have three general-purpose questions for you Excel/VBA experts. On all my sheets...
  3. M

    Sample Sorting

    Hi there I have a really confusing question , but I will try to make myself as clear as possible... So I have a registry Book, in which there are over 100 different worksheets, each asigned to a specific ''assay''. Each of them will have a cell called "Sample" next to which the sample number...
  4. S

    Macro Buttons

    Hi guys, thanks in advance for any help here, I have a small worksheet, nothing to advanced, however I have 2 buttons in it with 2 very short Macros attached to them, when I password protect the sheet I am unable to use these buttons, I get a "pop up" screen with 4 options, "Help", "End"...
  5. C

    Stopwatch / Timer w/ pause function

    I'm looking for a way to create a stopwatch/timer that can be paused and restarted without resetting. What this is doing is calculating how long it takes an employee to complete certain tasks. Whence the timer is stopped I need data in specified cells to be logged on another sheet along with...

Some videos you may like

This Week's Hot Topics