Search results

Thanks a ton ...its working now ...solved :)

i am doing anything wrong...still i am getting same error ""The X is disabled,please use the Save & Close button" while clicking ion button Public myRao AsBoolean PrivateSub Workbook_BeforeClose(Cancel AsBoolean) 'Run from "ThisWorkbook" module!If myRao = TrueThenExitSub...

Hi ..still i am geting same message " The X is disabled,please use the Save & Close button" and after clicking save & close button it shows same message and excel doesn't close

and the excel sheet is not getting closed

Hi Thanks for the code .. now the X disabled but when i click on Save & close button still its giving me the same message "The X is disabled,please use the Save & Close button"

it doesnt worked .. i have created form control button named save & close to save and close excel sheet in one instance. it is created in excel sheet only there is no userforms used.i have attached the pic and assigned below code to button Sub SaveAndClose() ActiveWorkbook.Save...

Hi all, i have excel sheet in that i have created form control button which save & close the excel. but few of my user not using the button but using X close at top right corner close option. i want my user to using this button so that in one instance they can save and close the excel , i...

Hi , i have pivot table with values , now i want to multiply those values with other values in different sheet in a such away that ,cell data look for the same user name first and then the values should get multiplied. small example below: sheet 1 abc_Report xyz_Report...

the changes you have mentioned seems working...but still i need to check for more time as my project in development stage ...i will defiantly keep you posted on this ..thanks for the help...

in this i am copying the data from TTM_Form to data_base form , in data_base work book i have sheet called workform in that if you click login hours button data should copy from TTM_Form to data_base "logintime" sheet. if you need more clarification let me know

i have small problem with workbook "data_base" ...after copying the data to another sheet the formula in column "D" should show like this below "=IF([@[Time Out]]="","",([Time Out]-[Time In])*24)" but its showing as below "=IF(TTM_Form.xlsm!Table2[@[Time Out]]="","",(TTM_Form.xlsm!Table2[Time...

Thanks Guys its working now...

Hi Forum, i am trying to add date & time to textbox, i have created a userform with combo box and text box in one of the textbox i am trying to display date & time but its not happening. datebox.Value = Format(Now(), "mm/dd/yyyy hh:mm:ss") and also tried Private Sub UserForm_Initialize()...

Hi Chihiro, Thanks for sharing code, in tried power query and its very easy and nothing to do with macros,but still i am trying to do something which is very easy for my team where they just select the date range and click the button to retrieve the data.i checked your code with few...

Hi Chihiro, PowerQuery is the only way we can do it or is there in VBA code to retrieve the data, i tried ADO method but i didnt worked for me.

Thanks for the links ad information i am using office 2016

Hi Team, i have created user form to enter data into excel data base that is connected to ms access, now i am trying to retrieve data from access data base , i have created group box with from date and to date with button to press but i am not sure how to write the code which select the from...

Hi Pcosta, by this i have completed my first project of making 15 reports automated, in this your contribution is unforgettable. and other forum members also helped me a lot.first i don't know a b c d of VB but once i was introduced to Chanddoo.org i learned a lot of coding. i came across many...

I will try and let u know...

Hi Pcosta, i will try and by the way i hope this will not effect the formula calculation. what i am looking for is once the formula calculation happens it should hide the formula, if it hide the formula before calculation we could not able to check some values. i got some thing like below but...

Hi , i have sheet with multiple complex formula in cell, after creating the report they are visible to all users. Is there anyway we can hide the formulas in excel sheet using vba code. only results from formula should be visible. Thanks,

Hi, for both the formulas header will be same,it looks like below . first formula counts the number of calls from H3:H5 and second formula should count the calls H9: till the calls count , this data keeps changing like calls count will increase or decrease daily. that's why i want it...

i have below formula but here i have to mention the row range ,is there any way it finds it dynamically. =SUMPRODUCT(--(sheet2!G2:G87=1)*(INT(sheet2!L2:L87)=TODAY()-1)) i have one more formula here i want the formula should calculate the row count after the above formula row count dynamically...

Hi, i have 12 sheets in workbook in that sheet8 is the sheet where all the sheets vlookup with, in sheet8 i have only one column "A" with list of Customer name. now i want what all 11 sheets should vlookup with sheet8 and what ever the names matches with sheet8 should be there which are not...

Hi, Please find attached sample file..