Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

macro problem in excel

Copper Contributor

when i am working in excel to make a dinamic data entry form.but there is so many problem i am face.i just use a simple formula like =d4*5% his formula isnt  work proparly.but when i use =d5*3% this time its work.however there is a big isue in my office 2021 in excel.when i am use macro record its work but i am try to active a button n click right button in my mouse i am not find the assine macro.its missing.i show u ............... 

ruben60_0-1683756165069.png

can any one tell me how can i solve this problem.plese help me how can i fix this problem.......

 

7 Replies

@ruben60 

 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

i appricieate you hans to respons my problem.but there is a problem i dont know how can i attach a sample workbook in one drive,google drive or dropbox or others.can you help me to how can i attach my sample pls.................just the direction howwwwwwwww?pls help..............hans..................
best response confirmed by ruben60 (Copper Contributor)
Solution

@ruben60 

As an alternative, you can attach the file to a Private Message to me (click on my avatar), or email it to

hans dot vogelaar at gmail dot com

@ruben60 

Thanks. You sent me a screenshot. It looks like you right-clicked on a cell.

Could you send me a copy of the workbook itself? You should be able to attach it to a private message.

email address removed for privacy reasons is this is your email id hans?pls confirm me i sent you a copy of my workbook..............
sir i sent a copy of my workbook.i apriciate you.............

@ruben60 

I have received your workbook. As I suspected, you hadn't created a button.

See the attached version. I created a button and streamlined the code a bit.

1 best response

Accepted Solutions
best response confirmed by ruben60 (Copper Contributor)
Solution

@ruben60 

As an alternative, you can attach the file to a Private Message to me (click on my avatar), or email it to

hans dot vogelaar at gmail dot com

View solution in original post