Recent content by Rishi

  1. R

    Shape Format toolbar not disabled in EXE

    In XLS Padlock under the Security > Restirctions settings, I selected ‘Disable all ribbons and toolbars’. The Excel file contains shapes. When opening the EXE, no toolbars are visible. However, when I click on one of the shapes, the ‘Shape Format’ toolbar pops up. How I prevent this from...
  2. R

    Compile error with copy as picture

    Sorry for the late reply, I managed to fix it. Thanks for your input!
  3. R

    Compile error with copy as picture

    Never mind, I changed the code to the following and it seems to work without problems. Sub CopyAsPicture(Param1) Application.Range("A6:H14").Select Application.Selection.CopyPicture Application.Range("O10").Select Application.ActiveSheet.Paste...
  4. R

    Compile error with copy as picture

    Hi, I’m running into a compiling problem with the following code, can you help solve this please? Sub CopyAsPicture(Param1) Application.Range("A6:H14").Select Application.Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture Application.Range("O10").Select Application.ActiveSheet.Paste...
See more
Back
Top