+ Reply to Thread
Results 1 to 8 of 8

Issue with shape renaming

  1. #1
    Registered User
    Join Date
    02-21-2020
    Location
    indiaa
    MS-Off Ver
    16
    Posts
    4

    Issue with shape renaming

    Hi ,
    i am designing label in excel. and want to rename shape when "link" button is clicked with unique name with reference to column name and increment number. kindly download excel to understand better what i am trying to achieve. once all shape have unique then shapes names can be linked to database for printing.

    Thank you.
    Attached Files Attached Files
    Last edited by akanjana; 03-26-2020 at 01:27 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Issue with shape renaming - expert please download excel sheet

    Will you please attach* a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

    3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

    To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

    attach <> link to external server
    Note some helpful comments (below rules part) in document: https://www.excelforum.com/forum-rul...rum-rules.html
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    02-21-2020
    Location
    indiaa
    MS-Off Ver
    16
    Posts
    4

    Re: Issue with shape renaming - expert please download excel sheet

    Hi kaper , my account is new at this forum, so i cannot attach file directly. therefore i have provided link to excel file in first thread. please check. thanks

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Issue with shape renaming - expert please download excel sheet

    If you had read the banner you would see that you always can add a sheet no matter how many posts you have.
    I will delete your link to the external file
    Thanks

  5. #5
    Registered User
    Join Date
    02-21-2020
    Location
    indiaa
    MS-Off Ver
    16
    Posts
    4

    Re: Issue with shape renaming - expert please download excel sheet

    Can you please do it for me. i just uploaded file. but not able to attach it. the attach option is not working for me. please understand.

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Issue with shape renaming - expert please download excel sheet

    Please read the yellow banner and follow instructions, the paperclip does not work...

  7. #7
    Registered User
    Join Date
    02-21-2020
    Location
    indiaa
    MS-Off Ver
    16
    Posts
    4

    Re: Issue with shape renaming

    Just uploaded. can you please help me with this.

  8. #8
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Issue with shape renaming

    Administrative Note:

    We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day . Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting issue, expert help needed
    By runestad in forum Excel General
    Replies: 3
    Last Post: 09-20-2018, 10:08 AM
  2. [SOLVED] Expert Needed: Conditional Formatting and SumIF/VlookUp issue (Last row)
    By newtotheblock in forum Excel General
    Replies: 4
    Last Post: 01-09-2015, 10:06 PM
  3. [SOLVED] Renaming A Shape
    By behrensf84 in forum Excel General
    Replies: 8
    Last Post: 12-11-2014, 12:13 PM
  4. [SOLVED] Extract specific data from a sheet created by a non-expert Excel user
    By gak67 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-18-2014, 12:00 AM
  5. Help With Excel Macro Renaming Row On Sheet
    By gaspower in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-08-2012, 04:45 PM
  6. [SOLVED] Help from expert needed with excel sheet please !
    By will2k in forum Excel General
    Replies: 8
    Last Post: 09-30-2012, 09:01 AM
  7. Excel hyperlink download issue
    By space108th in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-23-2009, 02:37 PM

Tags for this Thread

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