Hello,
This is Sebastiano. 33yo. Working in a biopharma CRO as a project
management. I am interested in using Excel to solve the shift planning and
resource tracking issues.
Ayush Jain於 2012年6月9日星期六 UTC+8上午3時21分59秒寫道：
>
> Hey all new and current posters,
>
> Welcome to excel group,one of t
How may I add a custom menu when one file is open, without using vba code?,
please see attachment, the file creates a new item *“Send Rows to Oracle
NCA”* under menu *“tools”,* when the file is closed the menu is deleted,
however there is no code in VBA code viewer, how is this possible?
-
rty2",MATCH(C8,Party2!A:A,
0)-1,IF(B8="Party3",MATCH(C8,Party3!A:A,0)-1,0))),0)
It worked for me, how could I reply attaching a reviewed file??
Regards,
Sebastian Ordonez
On May 5, 9:26 am, vidyut more wrote:
> I have attached sample file. I want for
Looks good, thanks.
On Feb 22, 6:23 am, VIRAL PANDYA wrote:
> Dear All,
>
> I am using the attached addins WST macro.
>
> and like to share the same with you all, may be helpful to you.
>
> Regards,
> Viral Pandya
> +91-992-432-1990
> +91-2632-230-474
>
> WSTMacros3.2.3.xla
> 680KViewDownload
-
delete all data from the sheets leaving just the VBA passsword
protected code, attach the file, once you have the password you can
paste back the data.
On Feb 20, 10:50 am, sunil sasidharan
wrote:
> Hi,
>
> I wont be able to send the file as it has some confidential data of our
> organisations.
>
I fixed it, without finding the root cause:
Private Sub Workbook_Open()
For Each ws In Worksheets
For Each dd In Worksheets(ws.Name).DropDowns
dd.Height = 15
Next
Next
end sub
It is not a good way, but it works. If anybody has an idea what the
root cause ist, please post it!
--
-
Hi,
I have the following problem, when I create some dropdown boxes via
VBA then all 99 ones have the some height and length in the excel
sheet. But when I save the file and open it again, then some of the
dropdown boxes are smaller or bigger then before. Has anybody a good
idea? Thank you
Code:
