$$Excel-Macros$$ disable copy in menue bar

dear all, is there a way to disable copy from menue bar?i have protected sheet it has disable copy but not from menue bar is there a way to do this its urgent? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thr

Re: $$Excel-Macros$$ printing an userform in pdf format

thank you santhosh On Thu, Mar 29, 2012 at 12:27 PM, Shankar Bheema wrote: > Dear experts > > I am using to take a printout of an userform by using the following code > in a command button: > > me.printform > > But, is there any option to take a softcopy of an unserform in a .pdf > format ? > > r

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

Dear Ravi, see attached sheet hope it will help to you. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Thu, Mar 29, 2012 at 5:37 PM, Ravi Kumar Vandavasi < friendswrite...@gmail.com> wrote: > Dear

Re: $$Excel-Macros$$ read sap ECC6 table content to excel using VBA

Hi, Don Guillett, sorry ,i can not open http://x61.ch/ee9a3f , this link can not work,the link is change to https://www.google.com/ .Thanks. Garcia On Thursday, March 29, 2012 8:28:40 PM UTC+8, Don Guillett wrote: > > http://x61.ch/ee9a3f > > Don Guillett > Microsoft MVP Excel > SalesAid

Re: $$Excel-Macros$$ Problem with Format Change Upon Data Validation Change Event

ou used range instead of target for your select but I would write it like this Or even simpler by ‘dim AType As Range ‘set AType = Range("S8:AL8") If Not Intersect(Target,range(“s8:al8”) is nothing then Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim SAType As Range Set SAType = Ran

Re: $$Excel-Macros$$

Read the forum rules at the bottom of each msg. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: vikin...@gmail.com Sent: Thursday, March 29, 2012 10:50 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Thanks in advance

Re: $$Excel-Macros$$ Problem with Format Change Upon Data Validation Change Event

Why not simply use conditional format? Sam Mathai Chacko On Thu, Mar 29, 2012 at 8:22 PM, Tiffany wrote: > Hi - > > I'm a little new to VBA but have managed to put together a macro that half > achieves its intended purpose. > > Depending on what is chosen in a data validation cell (any cell in

Re: $$Excel-Macros$$

The question violates the forum ethics. Read forum rule number 3. Regards, Sam On Thu, Mar 29, 2012 at 9:20 PM, wrote: > Thanks in advance > > > > Hi guys I have one xlsx file and it protected with password now after long > time I try to open that file but can't open it. Caz of password may b

$$Excel-Macros$$

Thanks in advance Hi guys I have one xlsx file and it protected with password now after long time I try to open that file but can't open it. Caz of password may b I forget that password or I use wrong password I try my all password but can't will you please give any solution for that or any

$$Excel-Macros$$ Problem with Format Change Upon Data Validation Change Event

Hi - I'm a little new to VBA but have managed to put together a macro that half achieves its intended purpose. Depending on what is chosen in a data validation cell (any cell in range S8 to AL8), the macro is supposed to change the format of 296 cells below the data validation cell: - If

Re: $$Excel-Macros$$ Unprotect - VBA Password

Read forum Rule, and abide by it please. Thank you. Regards, Sam On Thu, Mar 29, 2012 at 8:16 PM, amrahs k wrote: > Hi Team, > > I have created a tool in vba with password protected. I have forgot the > password. > > Now I want to do some changes in the tool based on the requirement. so > pleas

$$Excel-Macros$$ Unprotect - VBA Password

Hi Team, I have created a tool in vba with password protected. I have forgot the password. Now I want to do some changes in the tool based on the requirement. so please remove the vba password and send me the tool as soon as possible. Also it would be great if any one help me to create add ins.

Re: $$Excel-Macros$$ format a cell

hi Don,   Yes, I've used data validation, and forcing people to do tis in right way. But I need to sort past data and I'd like to learn from you all things that I won't find in the books.   Regards,   Pawel   PS macro I'm still not there. From: dguillett1 To: e

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

Maybe you could just change the format for all Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ravi Kumar Vandavasi Sent: Thursday, March 29, 2012 7:07 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Reading custom format as it appears in a c

Re: $$Excel-Macros$$ format a cell

BTW. You could use data validation to guide them to ONLY input as desired. Or, an input box macro. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Thursday, March 29, 2012 7:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

*Ignore Previous One. Shortcut key is Ctrl + F3* ** On Thu, Mar 29, 2012 at 4:40 PM, Maries wrote: > Hi, > > Try Below, > > 1. Select Cell C1 > 2. Press Shift+F3 > 3. Give Name as cellformat Refers to GET.CELL(7,A1) > > Use the formula in C1, =LEN(cellformat) > > Regards, > > MARIES. > On Thu, M

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

Hi, Try Below, 1. Select Cell C1 2. Press Shift+F3 3. Give Name as cellformat Refers to GET.CELL(7,A1) Use the formula in C1, =LEN(cellformat) Regards, MARIES. On Thu, Mar 29, 2012 at 4:34 PM, Maries wrote: > *PFA...* > > > On Thu, Mar 29, 2012 at 4:08 PM, Ravi Kumar Vandavasi < > friendswri

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

*PFA...* On Thu, Mar 29, 2012 at 4:08 PM, Ravi Kumar Vandavasi < friendswrite...@gmail.com> wrote: > Dear Sir, > > I have a series of Numbers where there might be less than 15 digits i.e. > custom format is used as "00" (14 instead of 15 or 16 instead > of 15). So, I need to identify

Re: $$Excel-Macros$$ read sap ECC6 table content to excel using VBA

http://x61.ch/ee9a3f Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Garcia Sent: Thursday, March 29, 2012 3:03 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ read sap ECC6 table content to excel using VBA Hi,expert, can you help me to read sap ta

Re: $$Excel-Macros$$ format a cell

Maries,   this is great, realy simplistic working fine, but what I find out today is that people have tendency to input "2.3" what means "02:30" but formula exchanging it to "00:23" can you help me on this? I've done something like that:   =IF(ISERROR(LEN(A1)-FIND(".",A1,1)),TIME(LEFT(TEXT(SUBSTI

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

Dear Sir, I have a series of Numbers where there might be less than 15 digits i.e. custom format is used as "00" (14 instead of 15 or 16 instead of 15). So, I need to identify these numbers which are wrongly custom formatted. For better understanding, please check the attached file

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

Dear Sir, Please find the excel sheet attached for better understanding. Regards, Ravi Kumar On Wednesday, March 28, 2012 4:04:29 PM UTC-7, Don Guillett wrote: > Do you mean values >0 such as 2 for the last example? > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille..

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

thanks for reply noorain But I want as in attached snapshot. Custom Menu hope you will help soon. Divaker On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan wrote: > Hi Noorain, > > Regarding the code provided from above, do the custom control button and > tab include all operations too? > > For

$$Excel-Macros$$ read sap ECC6 table content to excel using VBA

Hi,expert, can you help me to read sap table content (ECC 6) to excel with VBA,it's really thanks for your help. Garcia -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, C

Re: $$Excel-Macros$$ format a cell

Dear All, For these three conditions - 532, 1215 & 12.10, try below formula. =TIME(LEFT(TEXT(SUBSTITUTE(A1,".",""),""),2),RIGHT(TEXT(SUBSTITUTE(A1,".",""),""),2),0) Regards, MARIES. On Thu, Mar 29, 2012 at 10:16 AM, LAKSHMAN PRASAD wrote: > Dear All, > > If my input is 1215 or 12.15 c