Results 1 to 10 of 10

Error when calling a 'sheet macro' inside a workbook wide macro

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Connecticut
    MS-Off Ver
    Excel 2010
    Posts
    35

    Error when calling a 'sheet macro' inside a workbook wide macro

    I have a 'sheet macro' named Tabname_1 which simply renames the sheet tab based upon a cell value in the sheet. (By 'sheet macro' I mean that special kind of macro you create by right clicking on the tab name and selecting 'View Code'. It only applies to the current sheet.) Now I want to run this sheet macro within another larger macro that exists in the same workbook. But when I put 'Call Tabname_1' in the main macro I get the error: 'Sub or function not defined'. I also tried simply putting Tabname_1 instead of Call Tabname_1. But I get the same error.

    Is there some special syntax to call a sheet macro within a normal macro? Thanks
    Last edited by Rhino_dance; 08-09-2016 at 12:26 AM. Reason: typos

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro only runs from inside sheet not from another workbook/module
    By gabbana in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-30-2015, 06:40 AM
  2. [SOLVED] Define variable in macro than calling that macro inside another macro
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2015, 10:58 AM
  3. [SOLVED] Calling a macro inside another macro
    By MikeMeerkat in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-15-2015, 05:30 AM
  4. Error when calling macro
    By jamer02 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2013, 06:33 PM
  5. Help!! - Subscript Out of Range - Error while calling a workbook frmm another sheet..
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-29-2012, 12:53 PM
  6. Calling macro in another workbook
    By scabral in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2009, 02:03 PM
  7. Calling Macro From Different Workbook
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-23-2008, 07:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1