okay,
So I'm wondering if there is a way to disable the right click on my embedded excel app? I have the excel embedded within a panel, and no where else on the form can you right click
Any help would be greatly appreciated!
Printable View
okay,
So I'm wondering if there is a way to disable the right click on my embedded excel app? I have the excel embedded within a panel, and no where else on the form can you right click
Any help would be greatly appreciated!
An option here may be to handle right click from the workbook....
https://msdn.microsoft.com/en-us/lib.../ff192993.aspx
The way its set up the user only has access to the form nothing else, and I've tried the workbook_BeforeRightClick but can't seem to get it to work. I want the user to be able to enter data in the work book and i set up a button to save but I want to limit them to that.
How do you actually have Excel embedded? Through a web browser control or what?Quote:
Originally Posted by nebby_h
Ultimately it sounds like the typical scenario would be to restrict the actual workbook as I indicated earlier... Since you're just showing excel in your application, how would you make it work in Excel without your application... Or subscribe to the before right click event in Excel via your application and then cancel the event.
The thing that kind of sticks out to me is why not just let someone data collect on the form itself, and then export that data to an existing or new spreadsheet? Why does the Excel functionality matter at all if they are just entering and saving data?
I have the excel embedded within a panel. The excel functionality is important because these are manual inspection sheets for part tolerances, each of these sheets is different dependent on the different parts and different operations within each part, its changes so much its not something I could set with data collection I don't think.
How are you embedding the worksheet inside of a panel?Quote:
Originally Posted by nebby_h
Remember, if you can dream it, you can build it :). Your form could collect input and just fill it into the worksheets. Do all of your validation on the form controls and then simply insert the values into your sheet, or generate a sheet with the values from the form, etc.
My code looks something like this:
The issue with collecting data within the form is that there is information in regards to what kind of data to collect in the excel sheet, and I know I could just read the sheet and show it in the form but it changes its not like cells A1-A12 have the information and you input into B1-B12 and the info inside those cells changes no, the format changes all the time. Thats why I'm trying to disable the right click within the embedded excel. Question for you would it be possible to implement a macro within the excel worksheet as soon as my form opens it?Code:Dim APP As New Excel.Application
Dim worksheet As Excel.Worksheet
Dim workbook As Excel.Workbook
Private Const HT_CAPTION As Integer = &H2
Private Const WM_NCLBUTTONDOWN As Integer = &HA1
Declare Auto Function SetParent Lib "user32.dll" (ByVal hWndChild As IntPtr, ByVal hWndNewParent As IntPtr) As Integer
Declare Auto Function SendMessage Lib "user32.dll" (ByVal hWnd As IntPtr, ByVal Msg As Integer, ByVal wParam As Integer, ByVal lParam As Integer) As Integer
Private Const WM_SYSCOMMAND As Integer = 274
Private Const SC_MAXIMIZE As Integer = 61488
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
APP = New Excel.Application
workbook = APP.Workbooks.Open("C:\Users\nhrnjez\Documents\Jobs\Job" & jobnum & "\" & opnum & "\MI1")
SetParent(APP.Hwnd, Panel1.Handle)
SendMessage(APP.Hwnd, WM_SYSCOMMAND, SC_MAXIMIZE, 0)
End Sub
End Class