Re: macro to change sheet formats

One of my coworkers made a similar macro. I don't have it with me,
but I remember he had an issues with it. When you record the macro,
the call setting the sheet format has an extra argument that won't
play back. It's the argument telling the sheet format to be visible,
the last argument in the call. If you delete that one, then the macro
will run, but it will have the sheet format turned off. You'll need
to add an extra command to turn the sheet format back on.


.

Relevant Pages

  • Re: Links to multiple Worksheets
    ... Is there a way to apply a sheet format to the macro? ... first 6 lines of my sheets contain company info, date, job# etc. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: How to copy comment to grouped sheets, to same cell
    ... I'd record a macro when I selected the cell and added the comment. ... Then just rerun this macro for the other worksheets. ... sheet format) and paste it to rest of workbook sheets in same cell..thanks in ...
    (microsoft.public.excel.misc)
  • Re: macros do not work the same on different computers
    ... I think the macros are being run because when my coworkers are opening the ... Microsoft asks them if they want to enable macros. ... modify the macro so the first executable line after the Sub ... ColorCheck() line is a message box, ...
    (microsoft.public.word.vba.general)
  • Access Macros & the property "Visible"
    ... I am helping some coworkers with a problem with their ... The majority of their problems come from a macro not functioning. ... John ...
    (microsoft.public.access.macros)
  • Computer lock opens VB editor
    ... I installed a macro i designed on a coworkers ... computer and ever since then when ever she locks her computer using ... ctrl alt delete then unlocks it the VB editor opens up. ...
    (microsoft.public.excel.programming)