Log In
Register
Home
June 22, 2020
Offline
Dear all,
Can anyone tell me if I can move the form button from taskbar to somewhere else? I.e. in the header of the excel table below?
I only managed to add it to the taskbar and make new ribbon section and put it there.
I have a simple excel table where I have columns where I have the data and columns where I have to add the data manually, so I thought to use the form button and make it look more profesionally.
Thank you.
Best Regards,
Riste.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Riste,
Not sure what you mean by taskbar, that's a windows section on the bottom of the screen.
If you want to put something on the table headers, try a shape and assign to it the macro you want.
You can even import an image and assign a macro to it.
June 22, 2020
Offline
Hi Bombea, I meant for the Quick Access Toolbar on the top of the Excel window where you have the option for New Document, Save, Save As... rnThe button to open the Form is there. If you don't have it you can add it from the Options menu. I also found a way to add a new section in the Excel ribbon and there I add the Form the button. rnMy question was is there a way to add it somewhere down like a shape without making the file to be .xlsm.rn rnThank you.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Not without macros unfortunately.
1 Guest(s)
